<?php
	require_once('DataBase.php');
	//$journey_id = $_GET['journey_id'];
	$var = array();
	$sql=<<<SQL
	SELECT 
	`lat` AS lat,
	`long` AS lng,
	`image_thumb` AS thumbnail,
	`image_standard` AS url,
	`video_standard` AS video,
	`note` AS caption
	FROM `photo`
    WHERE journey_id = '0'
	
SQL;
	$result = mysql_query($sql);
	//$row = mysql_fetch_array($result);
	while($obj = mysql_fetch_object($result)) {
		$var[] = $obj;

	}

echo '{"rows":'.json_encode($var).'}';

	//$data = $result -> fetch( PDO::FETCH_ASSOC );
	//$json['data'] = $row;
		//echo  json_encode($json);




?>